prompt
prompt Creating sequence SEQ_SYS_DICTTYPE
prompt ==================================
prompt
create sequence TEST_03.SEQ_SYS_DICTTYPE
minvalue 1
maxvalue 999999999999999999999999
start with 153
increment by 1
cache 50;

prompt
prompt Creating sequence SEQ_SYS_RESOURCE
prompt ==================================
prompt
create sequence TEST_03.SEQ_SYS_RESOURCE
minvalue 1
maxvalue 999999999999999999999999
start with 101
increment by 1
cache 2;

prompt
prompt Creating sequence SEQ_SYS_ROLE
prompt ==============================
prompt
create sequence TEST_03.SEQ_SYS_ROLE
minvalue 1
maxvalue 9999999999999999999999999
start with 201
increment by 1
cache 50;

prompt
prompt Creating sequence SEQ_SYS_USER
prompt ==============================
prompt
create sequence TEST_03.SEQ_SYS_USER
minvalue 1
maxvalue 999999999999999999999999
start with 402
increment by 1
cache 50;

prompt
prompt Creating sequence SEQ_SYS_USER_LOGS
prompt ===================================
prompt
create sequence TEST_03.SEQ_SYS_USER_LOGS
minvalue 1
maxvalue 999999999999999999999999
start with 5242
increment by 1
cache 50;

prompt
prompt Creating trigger SYS_RESOURCE_TRIGGER
prompt =====================================
prompt
create or replace trigger test_03.SYS_RESOURCE_trigger
    before insert on sys_resources for each row

begin
    SELECT SEQ_SYS_RESOURCE.NEXTVAL INTO :NEW.ID FROM DUAL;
  end SYS_RESOURCE_trigger;
/

prompt
prompt Creating trigger SYS_ROLE_TRIGGER
prompt =================================
prompt
create or replace trigger test_03.SYS_ROLE_trigger
    before insert on sys_role for each row

begin
    SELECT SEQ_SYS_ROLE.NEXTVAL INTO :NEW.ID FROM DUAL;
  end SYS_ROLE_trigger;
/

prompt
prompt Creating trigger SYS_USER_LOGS_TRIGGER
prompt ======================================
prompt
create or replace trigger test_03.SYS_USER_LOGS_trigger
    before insert on sys_user_logs for each row

begin
    SELECT SEQ_SYS_USER_LOGS.NEXTVAL INTO :NEW.ID FROM DUAL;
  end SYS_USER_LOGS_trigger;
/

